/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50635
 Source Host           : localhost:3306
 Source Schema         : demo

 Target Server Type    : MySQL
 Target Server Version : 50635
 File Encoding         : 65001

 Date: 06/11/2018 11:12:57
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admins
-- ----------------------------
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(50) NOT NULL,
  `userpass` varchar(32) NOT NULL,
  `lastip` varchar(15) DEFAULT NULL,
  `lasttime` int(10) unsigned DEFAULT '0',
  `super` tinyint(1) unsigned DEFAULT '0',
  `role_id` int(10) NOT NULL DEFAULT '0' COMMENT '角色id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admins
-- ----------------------------
BEGIN;
INSERT INTO `admins` VALUES (1, 'SuperAdmin', '007f47716c391799f69f83e238dcef20', '127.0.0.1', 1541471314, 1, 0);
INSERT INTO `admins` VALUES (6, 'admin', '007f47716c391799f69f83e238dcef20', '127.0.0.1', 1541470342, 0, 1);
INSERT INTO `admins` VALUES (7, 'edibug', '007f47716c391799f69f83e238dcef20', '127.0.0.1', 1541412589, 0, 8);
COMMIT;

-- ----------------------------
-- Table structure for permission_role
-- ----------------------------
DROP TABLE IF EXISTS `permission_role`;
CREATE TABLE `permission_role` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `role_id` int(10) NOT NULL,
  `permissions` text NOT NULL,
  `created_at` int(11) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of permission_role
-- ----------------------------
BEGIN;
INSERT INTO `permission_role` VALUES (1, 1, 'a:2:{i:0;s:5:\"1-1-1\";i:1;s:5:\"1-2-1\";}', 1541408738, 1541408217);
INSERT INTO `permission_role` VALUES (3, 8, 'a:1:{i:0;s:5:\"1-1-1\";}', 1541408890, 1541412655);
COMMIT;

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT '1',
  `permission` text COLLATE utf8_unicode_ci,
  `route` text COLLATE utf8_unicode_ci,
  `created_at` int(10) DEFAULT NULL,
  `updated_at` int(10) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- ----------------------------
-- Records of roles
-- ----------------------------
BEGIN;
INSERT INTO `roles` VALUES (1, '系统默认管理员', 'npihuydyuhi1uad7', '管理员编辑', 1, 'a:39:{i:0;s:15:\"purview.setting\";i:1;s:18:\"permission.webinfo\";i:2;s:15:\"permission.logs\";i:3;s:21:\"permission.logintheme\";i:4;s:18:\"permission.initial\";i:5;s:15:\"permission.test\";i:6;s:17:\"permission.admins\";i:7;s:16:\"permission.roles\";i:8;s:12:\"purview.rule\";i:9;s:15:\"permission.mode\";i:10;s:18:\"permission.receipt\";i:11;s:17:\"permission.switch\";i:12;s:15:\"permission.vips\";i:14;s:12:\"purview.news\";i:15;s:19:\"permission.classify\";i:16;s:15:\"permission.news\";i:17;s:19:\"permission.bulletin\";i:18;s:19:\"permission.feedback\";i:19;s:19:\"permission.protocol\";i:20;s:13:\"purview.goods\";i:21;s:19:\"permission.addGoods\";i:22;s:19:\"permission.goodList\";i:23;s:16:\"permission.order\";i:24;s:12:\"purview.user\";i:25;s:16:\"permission.users\";i:26;s:16:\"permission.vipup\";i:27;s:19:\"permission.nodetree\";i:28;s:16:\"permission.ztree\";i:29;s:16:\"permission.debit\";i:30;s:20:\"permission.debit_log\";i:31;s:16:\"permission.bonus\";i:32;s:19:\"permission.transfer\";i:33;s:18:\"permission.consume\";i:34;s:13:\"permission.fh\";i:35;s:14:\"purview.worker\";i:36;s:22:\"permission.users_count\";i:37;s:26:\"permission.money_statement\";i:38;s:19:\"permission.withdraw\";i:39;s:16:\"permission.remit\";}', 'a:87:{i:0;s:16:\"admin.login-page\";i:1;s:15:\"admin.login-act\";i:2;s:16:\"admin.login-exit\";i:3;s:13:\"admin.welcome\";i:4;s:13:\"admin.setting\";i:5;s:17:\"admin.config.save\";i:6;s:10:\"admin.logs\";i:7;s:14:\"admin.logs.del\";i:8;s:17:\"admin.login.theme\";i:9;s:21:\"admin.login.theme.act\";i:10;s:13:\"admin.initial\";i:11;s:17:\"admin.initial.act\";i:12;s:21:\"admin.system.testPage\";i:13;s:17:\"admin.system.test\";i:14;s:12:\"admin.admins\";i:15;s:17:\"admin.admins.edit\";i:16;s:16:\"admin.roles.save\";i:17;s:15:\"admin.roles.del\";i:18;s:11:\"admin.roles\";i:19;s:16:\"admin.roles.edit\";i:20;s:16:\"admin.roles.save\";i:21;s:15:\"admin.roles.del\";i:22;s:10:\"admin.mode\";i:23;s:15:\"admin.mode.save\";i:24;s:13:\"admin.receipt\";i:25;s:18:\"admin.receipt.save\";i:26;s:12:\"admin.switch\";i:27;s:10:\"admin.vips\";i:28;s:15:\"admin.vips.save\";i:29;s:14:\"admin.vips.del\";i:30;s:14:\"admin.classify\";i:31;s:19:\"admin.classify.edit\";i:32;s:19:\"admin.classify.save\";i:33;s:18:\"admin.classify.del\";i:34;s:10:\"admin.news\";i:35;s:15:\"admin.news.edit\";i:36;s:15:\"admin.news.save\";i:37;s:14:\"admin.news.del\";i:38;s:13:\"admin.notices\";i:39;s:18:\"admin.notices.edit\";i:40;s:18:\"admin.notices.save\";i:41;s:17:\"admin.notices.del\";i:42;s:14:\"admin.feedback\";i:43;s:19:\"admin.feedback.edit\";i:44;s:20:\"admin.feedback.reply\";i:45;s:18:\"admin.feedback.del\";i:46;s:14:\"admin.protocol\";i:47;s:19:\"admin.protocol.save\";i:48;s:13:\"admin.product\";i:49;s:18:\"admin.product.save\";i:50;s:18:\"admin.product.list\";i:51;s:20:\"admin.product.status\";i:52;s:11:\"admin.order\";i:53;s:16:\"admin.order.edit\";i:54;s:16:\"admin.order.ship\";i:55;s:15:\"admin.order.del\";i:56;s:15:\"admin.order.end\";i:57;s:11:\"admin.users\";i:58;s:8:\"admin.go\";i:59;s:16:\"admin.users.edit\";i:60;s:16:\"admin.users.save\";i:61;s:17:\"admin.active.user\";i:62;s:14:\"admin.user.del\";i:63;s:17:\"admin.active.bdzx\";i:64;s:17:\"admin.user.freeze\";i:65;s:15:\"admin.user.stop\";i:66;s:11:\"admin.vipup\";i:67;s:16:\"admin.vipup.save\";i:68;s:15:\"admin.node.tree\";i:69;s:16:\"admin.node.zTree\";i:70;s:16:\"admin.debit.page\";i:71;s:15:\"admin.debit.act\";i:72;s:15:\"admin.debit.log\";i:73;s:11:\"admin.bonus\";i:74;s:14:\"admin.transfer\";i:75;s:13:\"admin.consume\";i:76;s:10:\"admin.ggfh\";i:77;s:18:\"admin.fHexport.act\";i:78;s:16:\"admin.user.count\";i:79;s:21:\"admin.money.statement\";i:80;s:14:\"admin.withdraw\";i:81;s:20:\"admin.withdraw.allow\";i:82;s:19:\"admin.withdraw.deny\";i:83;s:21:\"admin.withdraw.export\";i:84;s:11:\"admin.remit\";i:85;s:17:\"admin.remit.allow\";i:86;s:16:\"admin.remit.deny\";}', 1516063354, 1541408217);
INSERT INTO `roles` VALUES (8, '编辑者', 'VSqh5sCfuPiESiNK', '编辑内容', 1, NULL, NULL, 1541408890, 1541412655);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
